Design a Cash Flow layout

Note: This topic describes financial statements for Report Designer. If you want to produce financial statements for Excel Reporting, see How to design layouts for financial data reports (Excel Reporting).

About the Cash Flow report

The Cash Flow report allows you to project your cash flow from the present year to five years in advance, based on your Sage 200 budgets. Values are per accounting period, not calendar month.

For each accounting period, you can see:

• Opening balance.

  For the first period this is the actual balances for the nominal accounts, nominated as bank or cash accounts in the cash flow layout. The values used are the actual balance at the end of the period before the first period on the report.

  For all other periods, the opening cash balance is the closing cash position from the previous period.

• Value for each income heading.

  This value is based on the budgets for the nominal accounts associated with the income heading.

• Total cash receipts value (the sum of the values for all income headings).

• Value for each expenditure heading.

  This value is based on the budgets for the nominal accounts associated with the income heading.

• Total cash paid out (the sum of the values for all expenditure headings).

• Closing balance.

  This is the opening balance plus (total cash receipts less total cash paid out).

The Cash Flow report uses the actual balances for the nominal accounts, nominated as bank accounts in the cash flow layout.

Create a new layout

Open: Settings > Cash Book / Nominal Ledger > Financial Statement Layouts.

1. Select Cash Flow.
2. Click New.
3. Enter a name for the cash flow layout.
4. Click Edit.

Add your income

This is total income you've received, for example selling goods or services to your customers.

1. Create a text line for your income section.
   1. Choose Text from the Type drop-down list.
   2. Enter the heading text in the Title column, e.g. Income.
   3. Choose a heading style: 1 - 9.
2. Choose the report categories to include in your income section. This would usually be for your sales so add your Income report categories.
   1. Choose Single Account Group from the Type drop-down list.
   2. Choose the report category code from the drop-down list; e.g. 400 for Product Sales.
   3. Change the Title if required.

3. Repeat for all income report categories.

4. Create a total for the section.
   1. Choose Subtotal from the Type drop-down list.
   2. Enter some text in the Title column, such Total Income. The text is bold by default.

   3. Choose 1 in the subtotal level, as this adds up all rows above not included a subtotal.

Add your expenditure

This is the cost you've incurred to allow you to sell goods to your customers, such as the cost of labour.

1. Create a text line for your expenditure section.
   1. Choose Text from the Type drop-down list.
   2. Enter the heading text in the Title column, e.g. Outgoing.
   3. Choose a heading style: 1 - 9.
2. Enter the report categories to include in this section. Add the relevant Expense report categories.
   1. Choose Single Report Group from the Type drop-down list.
   2. Choose the report category code from the drop-down list; e.g. 600 for Labour.
   3. Change the Title if required.

3. Repeat for all expense report categories.

4. Create a total for the section.
   1. Choose Subtotal from the Type drop-down list.
   2. Enter some text in the Title column, such Total Outgoing. The text is bold by default.

   3. Choose 1 in the subtotal level. as this adds up all rows above not included in a sub total.

Add your bank accounts

Associate bank nominal accounts with a cash flow report to calculate the cash flow opening balance.

1. Click Nominal Accounts.
2. Select the required bank nominal accounts from the list.

Budget shift

Select a Budget Shift control value to specify the number of periods with which to shift the underlying budgets to reflect credit days.

For example, if you select a shift of 1, then you can take into account that cash will be received one period after budget. If you select a shift of 2, then you can take into account that cash will be received two periods after budget.

Note: The Budget Shift applies only to incomes and expenses, not to actuals.

Print your Cash Flow report

• To preview your Cash Flow report as you're designing it, click Print.
• Once you've finished designing the report, to run the Cash Flow report select Nominal > Nominal Reports > Financial Statements > Cash Flow Report.